package jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class LoginDemo {
    public static void main(String[] args) {
        UserInfo userInfo = InputUtil.getInputObject(new UserInfo(), "登录信息", "登录");

            try (
                    Connection connection = DBUtil.getConnection();
            ) {
                Statement statement = connection.createStatement();
                String sql = "SELECT id,username,password,nickname,age " +
                        "FROM userinfo " +
                        "WHERE username='" + userInfo.getUsername() + "' AND password='" + userInfo.getPassword() + "'";
                ResultSet rs = statement.executeQuery(sql);
                if (rs.next()) {
                    System.out.println("登录成功，欢迎你:" + rs.getString("nickname"));
                } else {
                    System.out.println("登录失败，用户名或密码不正确");
                }

            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }

